Download Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials.1z0-338.ActualTests.2018-10-09.40q.vcex

Vendor: Oracle
Exam Code: 1z0-338
Exam Name: Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials
Date: Oct 09, 2018
File Size: 58 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
In which three ways can customers access the ILOM interface to manage the Exadata database and storage server hardware components? (Choose three.) 
  1. ILOM CLI interface through the management network
  2. ILOM Web interface through the management network
  3. remote KVM session to the ILOM
  4. from the database server operating system tool "ilomcli"
  5. from the storage server operating system tool "ilomcli"
Correct answer: BCE
Question 2
Your customer is implementing a storage consolidation strategy on their existing Exadata. 
Which step represents the Oracle recommended action that the customer should take in their approach?
  1. Do not use IORM because it will interfere with the shared database functionality on Exadata.
  2. Use ASM to create separate diskgroups for each database instance that is running on Exadata.
  3. Use IORM to distribute disk bandwidth among the databases.
  4. Set up Oracle Grid Infrastructure to use multiple clusters per hardware pool.
  5. Set up a resource consumer group within each database instance and manage it individually.
Correct answer: C
Explanation:
Reference: http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata-300345.pdf page 42
Reference: http://www.oracle.com/technetwork/topics/cloud/whatsnew/mixedworkloadmgmtexadata-300345.pdf page 42
Question 3
How does Advanced Compression differ from Hybrid Columnar Compression?
  1. Advanced Compression is free to use on Exadata Database Machine, whereas Hybrid Columnar Compression must be purchased.
  2. They are the same; Advanced Compression is called Hybrid Columnar Compression on Exadata Database Machine.
  3. Hybrid Columnar Compression is good for tables with active updates and deletes, and provides deeper compression ratios.
  4. Advanced Compression is good for tables with active updates and deletes, whereas Hybrid Columnar Compression is best applied to tables or partitions where data is fairly static.
Correct answer: D
Question 4
The Exadata compute node, exadbs04, has been having issues for some time. The server had to be repaired and you just received a new server. Your LVM snapshot was corrupt and now the compute node must be re-imaged with an Oracle Support installation image. 
Which three tasks must be performed in order to re-image the compute node? (Choose three.)
  1. Create a CELLBOOT USB Flash Drive by using an external USB drive.
  2. Mount the LVM backup image across the network and recover the system.
  3. Remove exadbs04 from the RAC cluster and all associated Oracle Homes from the central inventory.
  4. Reboot the new server by using a bootable recovery image from the external USB drive.
  5. Reconfigure all site-specific settings (host name, IP addresses, NTP server, and so on).
Correct answer: CDE
Explanation:
Question 5
Which statement is true about instance caging setup?
  1. The initialization parameter resource_manager_plan should be set.
  2. For a system with 16 threads, the sum of cpu_count for all databases should not be higher than 32 to prevent oversubscribing.
  3. Database instances need to be restarted to make changes to cpu_count effective.
  4. The CPU Resource Manager and IORM need to be enabled to make instance caging to work as expected.
  5. Instance caging is the right approach to make sure that database instances are not stealin memory from one another.
Correct answer: A
Explanation:
Reference: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf
Reference: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf
Question 6
Which three tools can be used on a freshly re-imaged Exadata system to create, resize, or delete ACFS filesystems? (Choose three.)
  1. SQL*Plus and ASMCMD
  2. ASMCA
  3. Enterprise Manager Express
  4. Enterprise Manager Cloud Control
  5. RMAN
  6. OUI
Correct answer: ABC
Explanation:
Reference https://dbasolutions.wikispaces.com/ACFS+on+Linux
Reference https://dbasolutions.wikispaces.com/ACFS+on+Linux
Question 7
Your government customer has purchased a full rack of Exadata. The customer has two departments that would like to share the Exadata Database Machine but the concern is that department A will be able to see data from department B. 
Which architecture would you suggest to solve this deployment issue? 
  1. Split the configuration by using Oracle Nimbula's cloud software so that four database servers and seven cells can be used by department A and the rest can be used by department B.
  2. Split the configuration and use ASM-Scoped Security so that four database servers and seven cells can be used by department A and the rest can be used by department B.
  3. Set up instance caging to ensure that department A has access only to four database servers and seven cells and department B has access to the rest.
  4. Define the split by setting up database services that are specific to department A and department B.
Correct answer: D
Question 8
Which options does not benefit from storage offload processing?
  1. indexes that rely on B-Tree pointers
  2. column filtering
  3. joins and aggregation
  4. table scans
  5. incremental backups with block change tracking
Correct answer: A
Explanation:
Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/
Reference: https://www.pythian.com/blog/exadata-join-offloading-in-action/
Question 9
Your customer would like to configure monitoring capabilities alongside ASR on the stand-alone server that was set aside to run ASR Manager. 
What configuration would you set up for the customer?
  1. Enterprise Manager, SQL Developer Server, and ASR Manager on the stand-alone server because ASR needs SQL Developer to gain SQL access to the database server
  2. ASR Manager inside the firewall to ensure that root access to Exadata Database Machine is not compromised
  3. ASR Manager with SNMP traps configured to listen for specific alerts triggered by Exadata Database Machine 
  4. Enterprise Manager (Ops Center) and ASR Manager on the stand-alone server because ASR is not a monitoring tool
Correct answer: D
Question 10
What happens in an Exadata Database Machine when the DUPLICATE sub-clause of the INMEMORY attribute is specified?
  1. The DUPLICATE sub-clause enables parallel execution NUMA support.
  2. Each In-Memory Compression Unit in the IM column store will have a mirrored copy placed on another node in the RAC cluster. 
  3. The command allows the current instance to exceed DRAM limits and expand across memory, flash, and disk.
  4. The command creates an in-memory snapshot for write_only access.
  5. The In-Memory Compression Unit will have a mirrored copy placed on every other node in the RAC cluster.
Correct answer: B
Explanation:
Reference: http://www.oracle.com/technetwork/database/in-memory/learnmore/twp-dbim-exadata-2556211.pdf (page 3)
Reference: http://www.oracle.com/technetwork/database/in-memory/learnmore/twp-dbim-exadata-2556211.pdf (page 3)
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!